﻿/********************************************************************************************************************
* Author:	Christos Polydorou																						*
* Email:	std04237@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_getuseractivationcode" that returns	*
*			the code needed to activate a registered user.															*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_getuseractivationcode]
	@username nvarchar(50)
AS
	SELECT id, datecreated
	FROM users
	WHERE username = @username
RETURN 0